﻿/*
Post-Deployment Script Template							
--------------------------------------------------------------------------------------
 This file contains SQL statements that will be appended to the build script.		
 Use SQLCMD syntax to include a file in the post-deployment script.			
 Example:      :r .\myfile.sql								
 Use SQLCMD syntax to reference a variable in the post-deployment script.		
 Example:      :setvar TableName MyTable							
               SELECT * FROM [$(TableName)]					
--------------------------------------------------------------------------------------
*/

insert into countries (countrycode, countryname) values ('AL','Albania ')
insert into countries (countrycode, countryname) values ('DZ','Algeria ')
insert into countries (countrycode, countryname) values ('AD','Andorra ')
insert into countries (countrycode, countryname) values ('AO','Angola ')
insert into countries (countrycode, countryname) values ('AI','Anguilla ')
insert into countries (countrycode, countryname) values ('AG','Antigua And Barbuda ')
insert into countries (countrycode, countryname) values ('AE','Arab Emirates ')
insert into countries (countrycode, countryname) values ('AR','Argentina ')
insert into countries (countrycode, countryname) values ('AM','Armenia ')
insert into countries (countrycode, countryname) values ('AW','Aruba ')
insert into countries (countrycode, countryname) values ('AU','Australia ')
insert into countries (countrycode, countryname) values ('AT','Austria ')
insert into countries (countrycode, countryname) values ('AZ','Azerbaijan ')
insert into countries (countrycode, countryname) values ('BS','The Bahamas ')
insert into countries (countrycode, countryname) values ('BH','Bahrain ')
insert into countries (countrycode, countryname) values ('BD','Bangladesh ')
insert into countries (countrycode, countryname) values ('BB','Barbados ')
insert into countries (countrycode, countryname) values ('BY','Belarus ')
insert into countries (countrycode, countryname) values ('BE','Belgium ')
insert into countries (countrycode, countryname) values ('BZ','Belize ')
insert into countries (countrycode, countryname) values ('BM','Bermuda ')
insert into countries (countrycode, countryname) values ('BO','Bolivia ')
insert into countries (countrycode, countryname) values ('BA','Bosnia And Herzegovina ')
insert into countries (countrycode, countryname) values ('BW','Botswana ')
insert into countries (countrycode, countryname) values ('BR','Brazil ')
insert into countries (countrycode, countryname) values ('BN','Brunei ')
insert into countries (countrycode, countryname) values ('BG','Bulgaria ')
insert into countries (countrycode, countryname) values ('KH','Cambodia ')
insert into countries (countrycode, countryname) values ('CM','Cameroon ')
insert into countries (countrycode, countryname) values ('CA','Canada ')
insert into countries (countrycode, countryname) values ('KY','Cayman Islands ')
insert into countries (countrycode, countryname) values ('TD','Chad ')
insert into countries (countrycode, countryname) values ('CL','Chile ')
insert into countries (countrycode, countryname) values ('HK','China,Hong Kong S.A.R. ')
insert into countries (countrycode, countryname) values ('CN','China P.Rep. ')
insert into countries (countrycode, countryname) values ('CC','Cocos Islands ')
insert into countries (countrycode, countryname) values ('CO','Colombia ')
insert into countries (countrycode, countryname) values ('CD','Congo, Democratic Republic Of ')
insert into countries (countrycode, countryname) values ('CK','Cook Islands ')
insert into countries (countrycode, countryname) values ('CR','Costa Rica ')
insert into countries (countrycode, countryname) values ('HR','Croatia ')
insert into countries (countrycode, countryname) values ('CU','Cuba ')
insert into countries (countrycode, countryname) values ('CY','Cyprus ')
insert into countries (countrycode, countryname) values ('CZ','Czech Republic ')
insert into countries (countrycode, countryname) values ('CS','Czechoslovakia ')
insert into countries (countrycode, countryname) values ('DK','Denmark ')
insert into countries (countrycode, countryname) values ('DM','Dominica ')
insert into countries (countrycode, countryname) values ('DO','Dominican Repl. ')
insert into countries (countrycode, countryname) values ('EC','Ecuador ')
insert into countries (countrycode, countryname) values ('EG','Egypt ')
insert into countries (countrycode, countryname) values ('SV','El Salvador ')
insert into countries (countrycode, countryname) values ('EE','Estonia ')
insert into countries (countrycode, countryname) values ('ET','Ethiopia ')
insert into countries (countrycode, countryname) values ('FK','Falkland Islands (Malvinas) ')
insert into countries (countrycode, countryname) values ('FO','Faroe Islands ')
insert into countries (countrycode, countryname) values ('FJ','Fiji ')
insert into countries (countrycode, countryname) values ('FI','Finland ')
insert into countries (countrycode, countryname) values ('PF','Fr. Polynesia ')
insert into countries (countrycode, countryname) values ('GF','French Guiana ')
insert into countries (countrycode, countryname) values ('FR','France ')
insert into countries (countrycode, countryname) values ('GM','Gambia ')
insert into countries (countrycode, countryname) values ('GA','Gabon ')
insert into countries (countrycode, countryname) values ('GE','Georgia (Republic Of) ')
insert into countries (countrycode, countryname) values ('DE','Germany ')
insert into countries (countrycode, countryname) values ('GH','Ghana ')
insert into countries (countrycode, countryname) values ('GI','Gibraltar ')
insert into countries (countrycode, countryname) values ('GR','Greece ')
insert into countries (countrycode, countryname) values ('GL','Greenland ')
insert into countries (countrycode, countryname) values ('GD','Grenada ')
insert into countries (countrycode, countryname) values ('GP','Guadeloupe ')
insert into countries (countrycode, countryname) values ('GT','Guatemala ')
insert into countries (countrycode, countryname) values ('GN','Guinea ')
insert into countries (countrycode, countryname) values ('GY','Guyana ')
insert into countries (countrycode, countryname) values ('HT','Haiti ')
insert into countries (countrycode, countryname) values ('HN','Honduras ')
insert into countries (countrycode, countryname) values ('HU','Hungary ')
insert into countries (countrycode, countryname) values ('IS','Iceland ')
insert into countries (countrycode, countryname) values ('IN','India ')
insert into countries (countrycode, countryname) values ('ID','Indonesia ')
insert into countries (countrycode, countryname) values ('IR','Iran ')
insert into countries (countrycode, countryname) values ('IQ','Iraq ')
insert into countries (countrycode, countryname) values ('IE','Ireland ')
insert into countries (countrycode, countryname) values ('IL','Israel ')
insert into countries (countrycode, countryname) values ('IT','Italy ')
insert into countries (countrycode, countryname) values ('CI','Ivory Coast ')
insert into countries (countrycode, countryname) values ('JM','Jamaica ')
insert into countries (countrycode, countryname) values ('JP','Japan ')
insert into countries (countrycode, countryname) values ('JO','Jordan ')
insert into countries (countrycode, countryname) values ('KZ','Kazakhstan ')
insert into countries (countrycode, countryname) values ('KE','Kenya ')
insert into countries (countrycode, countryname) values ('KW','Kuwait ')
insert into countries (countrycode, countryname) values ('KG','Kyrgyzstan ')
insert into countries (countrycode, countryname) values ('LA','Laos ')
insert into countries (countrycode, countryname) values ('LV','Latvia ')
insert into countries (countrycode, countryname) values ('LB','Lebanon ')
insert into countries (countrycode, countryname) values ('LR','Liberia ')
insert into countries (countrycode, countryname) values ('LY','Libya ')
insert into countries (countrycode, countryname) values ('LI','Liechtenstein ')
insert into countries (countrycode, countryname) values ('LT','Lithuania ')
insert into countries (countrycode, countryname) values ('LU','Luxembourg ')
insert into countries (countrycode, countryname) values ('MO','Macau ')
insert into countries (countrycode, countryname) values ('MK','Macedonia, Former Yugoslav Rep. ')
insert into countries (countrycode, countryname) values ('MG','Madagascar ')
insert into countries (countrycode, countryname) values ('MW','Malawi ')
insert into countries (countrycode, countryname) values ('MY','Malaysia ')
insert into countries (countrycode, countryname) values ('ML','Mali ')
insert into countries (countrycode, countryname) values ('MT','Malta ')
insert into countries (countrycode, countryname) values ('MH','Marshall Islands ')
insert into countries (countrycode, countryname) values ('MQ','Martinique ')
insert into countries (countrycode, countryname) values ('MR','Mauritania ')
insert into countries (countrycode, countryname) values ('MU','Mauritius ')
insert into countries (countrycode, countryname) values ('MX','Mexico ')
insert into countries (countrycode, countryname) values ('MD','Moldova, Republic Of ')
insert into countries (countrycode, countryname) values ('MC','Monaco ')
insert into countries (countrycode, countryname) values ('MA','Morocco ')
insert into countries (countrycode, countryname) values ('MM','Myanmar ')
insert into countries (countrycode, countryname) values ('NA','Namibia ')
insert into countries (countrycode, countryname) values ('NP','Nepal ')
insert into countries (countrycode, countryname) values ('AN','Neth. Antilles ')
insert into countries (countrycode, countryname) values ('NL','Netherlands ')
insert into countries (countrycode, countryname) values ('NC','New Caledonia ')
insert into countries (countrycode, countryname) values ('PG','New Guinea ')
insert into countries (countrycode, countryname) values ('NZ','New Zealand ')
insert into countries (countrycode, countryname) values ('NI','Nicaragua ')
insert into countries (countrycode, countryname) values ('NE','Niger ')
insert into countries (countrycode, countryname) values ('NG','Nigeria ')
insert into countries (countrycode, countryname) values ('NF','Norfolk Island ')
insert into countries (countrycode, countryname) values ('KP','North Korea ')
insert into countries (countrycode, countryname) values ('NO','Norway ')
insert into countries (countrycode, countryname) values ('OM','Oman ')
insert into countries (countrycode, countryname) values ('PK','Pakistan ')
insert into countries (countrycode, countryname) values ('PA','Panama ')
insert into countries (countrycode, countryname) values ('PY','Paraguay ')
insert into countries (countrycode, countryname) values ('PE','Peru ')
insert into countries (countrycode, countryname) values ('PH','Philippines ')
insert into countries (countrycode, countryname) values ('PL','Poland ')
insert into countries (countrycode, countryname) values ('PT','Portugal ')
insert into countries (countrycode, countryname) values ('PW','Palau ')
insert into countries (countrycode, countryname) values ('QA','Qatar ')
insert into countries (countrycode, countryname) values ('RO','Romania ')
insert into countries (countrycode, countryname) values ('RU','Russian Federation ')
insert into countries (countrycode, countryname) values ('KN','Saint Kitts And Nevis ')
insert into countries (countrycode, countryname) values ('SM','San Marino ')
insert into countries (countrycode, countryname) values ('SA','Saudi Arabia ')
insert into countries (countrycode, countryname) values ('SN','Senegal ')
insert into countries (countrycode, countryname) values ('SL','Sierra Leone ')
insert into countries (countrycode, countryname) values ('SG','Singapore ')
insert into countries (countrycode, countryname) values ('SK','Slovakia ')
insert into countries (countrycode, countryname) values ('SI','Slovenia ')
insert into countries (countrycode, countryname) values ('SB','Solomon Islands ')
insert into countries (countrycode, countryname) values ('ZA','South Africa ')
insert into countries (countrycode, countryname) values ('KR','South Korea ')
insert into countries (countrycode, countryname) values ('ES','Spain ')
insert into countries (countrycode, countryname) values ('LK','Sri Lanka ')
insert into countries (countrycode, countryname) values ('LC','St. Lucia ')
insert into countries (countrycode, countryname) values ('VC','St. Vincent/Grenadines ')
insert into countries (countrycode, countryname) values ('SD','Sudan ')
insert into countries (countrycode, countryname) values ('SR','Suriname ')
insert into countries (countrycode, countryname) values ('SZ','Swaziland ')
insert into countries (countrycode, countryname) values ('SE','Sweden ')
insert into countries (countrycode, countryname) values ('CH','Switzerland ')
insert into countries (countrycode, countryname) values ('SY','Syria ')
insert into countries (countrycode, countryname) values ('TW','Taiwan ')
insert into countries (countrycode, countryname) values ('TZ','Tanzania ')
insert into countries (countrycode, countryname) values ('TH','Thailand ')
insert into countries (countrycode, countryname) values ('TT','Trinidad/Tobago ')
insert into countries (countrycode, countryname) values ('TN','Tunisia ')
insert into countries (countrycode, countryname) values ('TR','Turkey ')
insert into countries (countrycode, countryname) values ('TC','Turks And Caicos Islands ')
insert into countries (countrycode, countryname) values ('SU','U.S.S.R. ')
insert into countries (countrycode, countryname) values ('UG','Uganda ')
insert into countries (countrycode, countryname) values ('UA','Ukraine ')
insert into countries (countrycode, countryname) values ('GB','United Kingdom ')
insert into countries (countrycode, countryname) values ('UY','Uruguay ')
insert into countries (countrycode, countryname) values ('UZ','Uzbekistan ')
insert into countries (countrycode, countryname) values ('VU','Vanuatu (New Hebrides) ')
insert into countries (countrycode, countryname) values ('VA','Vatican City State (Holy See) ')
insert into countries (countrycode, countryname) values ('VE','Venezuela ')
insert into countries (countrycode, countryname) values ('VN','Viet Nam ')
insert into countries (countrycode, countryname) values ('VG','Virgin (British) Islands ')
insert into countries (countrycode, countryname) values ('YE','Yemen ')
insert into countries (countrycode, countryname) values ('YU','Yugoslavia ')
insert into countries (countrycode, countryname) values ('ZM','Zambia ')
insert into countries (countrycode, countryname) values ('ZW','Zimbabwe')


insert into ProfessionalBackgrounds (ProfessionalBackgroundName) values ('Manager');
insert into ProfessionalBackgrounds (ProfessionalBackgroundName) values ('Nurse');
insert into ProfessionalBackgrounds (ProfessionalBackgroundName) values ('Clinical laboratory technician');
insert into ProfessionalBackgrounds (ProfessionalBackgroundName) values ('Physician');
insert into ProfessionalBackgrounds (ProfessionalBackgroundName) values ('Administration staff');
insert into ProfessionalBackgrounds (ProfessionalBackgroundName) values ('Others');

insert into Specialities (SpecialityName) values ('Anaesthesiology');
insert into Specialities (SpecialityName) values ('Critical care');
insert into Specialities (SpecialityName) values ('Emergencies');
insert into Specialities (SpecialityName) values ('Orthopaedics');
insert into Specialities (SpecialityName) values ('Others');
insert into Specialities (SpecialityName) values ('General surgery');
insert into Specialities (SpecialityName) values ('Neurosurgery');
insert into Specialities (SpecialityName) values ('Cardiac thoracic surgery');
insert into Specialities (SpecialityName) values ('Other surgery');
insert into Specialities (SpecialityName) values ('Nephrology');
insert into Specialities (SpecialityName) values ('Urology');
insert into Specialities (SpecialityName) values ('No speciality');

insert into Genders (GenderName) values ('Male');
insert into Genders (GenderName) values ('Female');

